package com.teamall.web.tssy.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class TsSyUserArg {
    private String pk_name = "ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<TsSyUserCriteria> oredCriteria;

    public TsSyUserArg() {
        oredCriteria = new ArrayList<TsSyUserCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<TsSyUserCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(TsSyUserCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public TsSyUserCriteria or() {
    	TsSyUserCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public TsSyUserCriteria createCriteria() {
    	TsSyUserCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected TsSyUserCriteria createCriteriaInternal() {
    	TsSyUserCriteria criteria = new TsSyUserCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<TsSyUserCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<TsSyUserCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<TsSyUserCriterion> getAllCriteria() {
            return criteria;
        }

        public List<TsSyUserCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new TsSyUserCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new TsSyUserCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new TsSyUserCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new TsSyUserCriterion(condition, value1, value2));
        }

        public TsSyUserCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andIdIsNull() {
            addCriterion("ID is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdLessThan(String value) {
            addCriterion("ID <", value, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdLike(String value) {
            addCriterion("ID like ", value, "ID", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdNotLike(String value) {
            addCriterion("ID  not like ", value, "ID", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdLeftLike(String value) {
            addCriterion("ID like ", value, "ID", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdNotLeftLike(String value) {
            addCriterion("ID  not like ", value, "ID", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdRightLike(String value) {
            addCriterion("ID like ", value, "ID", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdNotRightLike(String value) {
            addCriterion("ID  not like ", value, "ID", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdIn(List<String> values) {
            addCriterion("ID  in ", values, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdNotIn(List<String> values) {
            addCriterion("ID not in ", values, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdBetween(String value1, String value2) {
            addCriterion("ID between ", value1, value2, "ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between ", value1, value2, "ID");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andSexIsNull() {
            addCriterion("SEX is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexIsNotNull() {
            addCriterion("SEX is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexEqualTo(String value) {
            addCriterion("SEX =", value, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexNotEqualTo(String value) {
            addCriterion("SEX <>", value, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexGreaterThan(String value) {
            addCriterion("SEX >", value, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("SEX >=", value, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexLessThan(String value) {
            addCriterion("SEX <", value, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexLessThanOrEqualTo(String value) {
            addCriterion("SEX <=", value, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexLike(String value) {
            addCriterion("SEX like ", value, "SEX", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexNotLike(String value) {
            addCriterion("SEX  not like ", value, "SEX", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexLeftLike(String value) {
            addCriterion("SEX like ", value, "SEX", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexNotLeftLike(String value) {
            addCriterion("SEX  not like ", value, "SEX", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexRightLike(String value) {
            addCriterion("SEX like ", value, "SEX", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexNotRightLike(String value) {
            addCriterion("SEX  not like ", value, "SEX", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexIn(List<String> values) {
            addCriterion("SEX  in ", values, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexNotIn(List<String> values) {
            addCriterion("SEX not in ", values, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexBetween(String value1, String value2) {
            addCriterion("SEX between ", value1, value2, "SEX");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andSexNotBetween(String value1, String value2) {
            addCriterion("SEX not between ", value1, value2, "SEX");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andLoginNameIsNull() {
            addCriterion("LOGIN_NAME is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameIsNotNull() {
            addCriterion("LOGIN_NAME is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameEqualTo(String value) {
            addCriterion("LOGIN_NAME =", value, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameNotEqualTo(String value) {
            addCriterion("LOGIN_NAME <>", value, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameGreaterThan(String value) {
            addCriterion("LOGIN_NAME >", value, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameGreaterThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME >=", value, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameLessThan(String value) {
            addCriterion("LOGIN_NAME <", value, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameLessThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME <=", value, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameLike(String value) {
            addCriterion("LOGIN_NAME like ", value, "LOGIN_NAME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameNotLike(String value) {
            addCriterion("LOGIN_NAME  not like ", value, "LOGIN_NAME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameLeftLike(String value) {
            addCriterion("LOGIN_NAME like ", value, "LOGIN_NAME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameNotLeftLike(String value) {
            addCriterion("LOGIN_NAME  not like ", value, "LOGIN_NAME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameRightLike(String value) {
            addCriterion("LOGIN_NAME like ", value, "LOGIN_NAME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameNotRightLike(String value) {
            addCriterion("LOGIN_NAME  not like ", value, "LOGIN_NAME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameIn(List<String> values) {
            addCriterion("LOGIN_NAME  in ", values, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameNotIn(List<String> values) {
            addCriterion("LOGIN_NAME not in ", values, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME between ", value1, value2, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andLoginNameNotBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME not between ", value1, value2, "LOGIN_NAME");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordLike(String value) {
            addCriterion("PASSWORD like ", value, "PASSWORD", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD  not like ", value, "PASSWORD", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordLeftLike(String value) {
            addCriterion("PASSWORD like ", value, "PASSWORD", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordNotLeftLike(String value) {
            addCriterion("PASSWORD  not like ", value, "PASSWORD", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordRightLike(String value) {
            addCriterion("PASSWORD like ", value, "PASSWORD", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordNotRightLike(String value) {
            addCriterion("PASSWORD  not like ", value, "PASSWORD", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD  in ", values, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in ", values, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between ", value1, value2, "PASSWORD");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between ", value1, value2, "PASSWORD");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andRealNameIsNull() {
            addCriterion("REAL_NAME is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameIsNotNull() {
            addCriterion("REAL_NAME is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameEqualTo(String value) {
            addCriterion("REAL_NAME =", value, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameNotEqualTo(String value) {
            addCriterion("REAL_NAME <>", value, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameGreaterThan(String value) {
            addCriterion("REAL_NAME >", value, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameGreaterThanOrEqualTo(String value) {
            addCriterion("REAL_NAME >=", value, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameLessThan(String value) {
            addCriterion("REAL_NAME <", value, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameLessThanOrEqualTo(String value) {
            addCriterion("REAL_NAME <=", value, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameLike(String value) {
            addCriterion("REAL_NAME like ", value, "REAL_NAME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameNotLike(String value) {
            addCriterion("REAL_NAME  not like ", value, "REAL_NAME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameLeftLike(String value) {
            addCriterion("REAL_NAME like ", value, "REAL_NAME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameNotLeftLike(String value) {
            addCriterion("REAL_NAME  not like ", value, "REAL_NAME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameRightLike(String value) {
            addCriterion("REAL_NAME like ", value, "REAL_NAME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameNotRightLike(String value) {
            addCriterion("REAL_NAME  not like ", value, "REAL_NAME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameIn(List<String> values) {
            addCriterion("REAL_NAME  in ", values, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameNotIn(List<String> values) {
            addCriterion("REAL_NAME not in ", values, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameBetween(String value1, String value2) {
            addCriterion("REAL_NAME between ", value1, value2, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRealNameNotBetween(String value1, String value2) {
            addCriterion("REAL_NAME not between ", value1, value2, "REAL_NAME");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andDeptIdIsNull() {
            addCriterion("DEPT_ID is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdIsNotNull() {
            addCriterion("DEPT_ID is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdEqualTo(String value) {
            addCriterion("DEPT_ID =", value, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdNotEqualTo(String value) {
            addCriterion("DEPT_ID <>", value, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdGreaterThan(String value) {
            addCriterion("DEPT_ID >", value, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdGreaterThanOrEqualTo(String value) {
            addCriterion("DEPT_ID >=", value, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdLessThan(String value) {
            addCriterion("DEPT_ID <", value, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdLessThanOrEqualTo(String value) {
            addCriterion("DEPT_ID <=", value, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdLike(String value) {
            addCriterion("DEPT_ID like ", value, "DEPT_ID", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdNotLike(String value) {
            addCriterion("DEPT_ID  not like ", value, "DEPT_ID", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdLeftLike(String value) {
            addCriterion("DEPT_ID like ", value, "DEPT_ID", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdNotLeftLike(String value) {
            addCriterion("DEPT_ID  not like ", value, "DEPT_ID", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdRightLike(String value) {
            addCriterion("DEPT_ID like ", value, "DEPT_ID", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdNotRightLike(String value) {
            addCriterion("DEPT_ID  not like ", value, "DEPT_ID", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdIn(List<String> values) {
            addCriterion("DEPT_ID  in ", values, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdNotIn(List<String> values) {
            addCriterion("DEPT_ID not in ", values, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdBetween(String value1, String value2) {
            addCriterion("DEPT_ID between ", value1, value2, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andDeptIdNotBetween(String value1, String value2) {
            addCriterion("DEPT_ID not between ", value1, value2, "DEPT_ID");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailLike(String value) {
            addCriterion("EMAIL like ", value, "EMAIL", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailNotLike(String value) {
            addCriterion("EMAIL  not like ", value, "EMAIL", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailLeftLike(String value) {
            addCriterion("EMAIL like ", value, "EMAIL", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailNotLeftLike(String value) {
            addCriterion("EMAIL  not like ", value, "EMAIL", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailRightLike(String value) {
            addCriterion("EMAIL like ", value, "EMAIL", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailNotRightLike(String value) {
            addCriterion("EMAIL  not like ", value, "EMAIL", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailIn(List<String> values) {
            addCriterion("EMAIL  in ", values, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in ", values, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between ", value1, value2, "EMAIL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between ", value1, value2, "EMAIL");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andMobileIsNull() {
            addCriterion("MOBILE is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileIsNotNull() {
            addCriterion("MOBILE is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileEqualTo(String value) {
            addCriterion("MOBILE =", value, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileNotEqualTo(String value) {
            addCriterion("MOBILE <>", value, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileGreaterThan(String value) {
            addCriterion("MOBILE >", value, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE >=", value, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileLessThan(String value) {
            addCriterion("MOBILE <", value, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("MOBILE <=", value, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileLike(String value) {
            addCriterion("MOBILE like ", value, "MOBILE", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileNotLike(String value) {
            addCriterion("MOBILE  not like ", value, "MOBILE", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileLeftLike(String value) {
            addCriterion("MOBILE like ", value, "MOBILE", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileNotLeftLike(String value) {
            addCriterion("MOBILE  not like ", value, "MOBILE", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileRightLike(String value) {
            addCriterion("MOBILE like ", value, "MOBILE", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileNotRightLike(String value) {
            addCriterion("MOBILE  not like ", value, "MOBILE", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileIn(List<String> values) {
            addCriterion("MOBILE  in ", values, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileNotIn(List<String> values) {
            addCriterion("MOBILE not in ", values, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileBetween(String value1, String value2) {
            addCriterion("MOBILE between ", value1, value2, "MOBILE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andMobileNotBetween(String value1, String value2) {
            addCriterion("MOBILE not between ", value1, value2, "MOBILE");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andIsDelIsNull() {
            addCriterion("IS_DEL is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelIsNotNull() {
            addCriterion("IS_DEL is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelEqualTo(String value) {
            addCriterion("IS_DEL =", value, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelNotEqualTo(String value) {
            addCriterion("IS_DEL <>", value, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelGreaterThan(String value) {
            addCriterion("IS_DEL >", value, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DEL >=", value, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelLessThan(String value) {
            addCriterion("IS_DEL <", value, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelLessThanOrEqualTo(String value) {
            addCriterion("IS_DEL <=", value, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelLike(String value) {
            addCriterion("IS_DEL like ", value, "IS_DEL", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelNotLike(String value) {
            addCriterion("IS_DEL  not like ", value, "IS_DEL", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelLeftLike(String value) {
            addCriterion("IS_DEL like ", value, "IS_DEL", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelNotLeftLike(String value) {
            addCriterion("IS_DEL  not like ", value, "IS_DEL", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelRightLike(String value) {
            addCriterion("IS_DEL like ", value, "IS_DEL", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelNotRightLike(String value) {
            addCriterion("IS_DEL  not like ", value, "IS_DEL", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelIn(List<String> values) {
            addCriterion("IS_DEL  in ", values, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelNotIn(List<String> values) {
            addCriterion("IS_DEL not in ", values, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelBetween(String value1, String value2) {
            addCriterion("IS_DEL between ", value1, value2, "IS_DEL");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsDelNotBetween(String value1, String value2) {
            addCriterion("IS_DEL not between ", value1, value2, "IS_DEL");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andBirthDateIsNull() {
            addCriterion("BIRTH_DATE is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateIsNotNull() {
            addCriterion("BIRTH_DATE is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateEqualTo(Date value) {
            addCriterion("BIRTH_DATE =", value, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateNotEqualTo(Date value) {
            addCriterion("BIRTH_DATE <>", value, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateGreaterThan(Date value) {
            addCriterion("BIRTH_DATE >", value, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateGreaterThanOrEqualTo(Date value) {
            addCriterion("BIRTH_DATE >=", value, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateLessThan(Date value) {
            addCriterion("BIRTH_DATE <", value, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateLessThanOrEqualTo(Date value) {
            addCriterion("BIRTH_DATE <=", value, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateLike(Date value) {
            addCriterion("BIRTH_DATE like ", value, "BIRTH_DATE", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateNotLike(Date value) {
            addCriterion("BIRTH_DATE  not like ", value, "BIRTH_DATE", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateLeftLike(Date value) {
            addCriterion("BIRTH_DATE like ", value, "BIRTH_DATE", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateNotLeftLike(Date value) {
            addCriterion("BIRTH_DATE  not like ", value, "BIRTH_DATE", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateRightLike(Date value) {
            addCriterion("BIRTH_DATE like ", value, "BIRTH_DATE", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateNotRightLike(Date value) {
            addCriterion("BIRTH_DATE  not like ", value, "BIRTH_DATE", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateIn(List<Date> values) {
            addCriterion("BIRTH_DATE  in ", values, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateNotIn(List<Date> values) {
            addCriterion("BIRTH_DATE not in ", values, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateBetween(Date value1, Date value2) {
            addCriterion("BIRTH_DATE between ", value1, value2, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andBirthDateNotBetween(Date value1, Date value2) {
            addCriterion("BIRTH_DATE not between ", value1, value2, "BIRTH_DATE");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeLike(Date value) {
            addCriterion("CREATE_TIME like ", value, "CREATE_TIME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeNotLike(Date value) {
            addCriterion("CREATE_TIME  not like ", value, "CREATE_TIME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeLeftLike(Date value) {
            addCriterion("CREATE_TIME like ", value, "CREATE_TIME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeNotLeftLike(Date value) {
            addCriterion("CREATE_TIME  not like ", value, "CREATE_TIME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeRightLike(Date value) {
            addCriterion("CREATE_TIME like ", value, "CREATE_TIME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeNotRightLike(Date value) {
            addCriterion("CREATE_TIME  not like ", value, "CREATE_TIME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME  in ", values, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in ", values, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between ", value1, value2, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between ", value1, value2, "CREATE_TIME");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andCreateByIsNull() {
            addCriterion("CREATE_BY is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByIsNotNull() {
            addCriterion("CREATE_BY is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByEqualTo(String value) {
            addCriterion("CREATE_BY =", value, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByNotEqualTo(String value) {
            addCriterion("CREATE_BY <>", value, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByGreaterThan(String value) {
            addCriterion("CREATE_BY >", value, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY >=", value, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByLessThan(String value) {
            addCriterion("CREATE_BY <", value, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY <=", value, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByLike(String value) {
            addCriterion("CREATE_BY like ", value, "CREATE_BY", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByNotLike(String value) {
            addCriterion("CREATE_BY  not like ", value, "CREATE_BY", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByLeftLike(String value) {
            addCriterion("CREATE_BY like ", value, "CREATE_BY", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByNotLeftLike(String value) {
            addCriterion("CREATE_BY  not like ", value, "CREATE_BY", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByRightLike(String value) {
            addCriterion("CREATE_BY like ", value, "CREATE_BY", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByNotRightLike(String value) {
            addCriterion("CREATE_BY  not like ", value, "CREATE_BY", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByIn(List<String> values) {
            addCriterion("CREATE_BY  in ", values, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByNotIn(List<String> values) {
            addCriterion("CREATE_BY not in ", values, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByBetween(String value1, String value2) {
            addCriterion("CREATE_BY between ", value1, value2, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY not between ", value1, value2, "CREATE_BY");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeLike(Date value) {
            addCriterion("UPDATE_TIME like ", value, "UPDATE_TIME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeNotLike(Date value) {
            addCriterion("UPDATE_TIME  not like ", value, "UPDATE_TIME", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeLeftLike(Date value) {
            addCriterion("UPDATE_TIME like ", value, "UPDATE_TIME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeNotLeftLike(Date value) {
            addCriterion("UPDATE_TIME  not like ", value, "UPDATE_TIME", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeRightLike(Date value) {
            addCriterion("UPDATE_TIME like ", value, "UPDATE_TIME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeNotRightLike(Date value) {
            addCriterion("UPDATE_TIME  not like ", value, "UPDATE_TIME", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME  in ", values, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in ", values, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between ", value1, value2, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between ", value1, value2, "UPDATE_TIME");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andUpdateByIsNull() {
            addCriterion("UPDATE_BY is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByIsNotNull() {
            addCriterion("UPDATE_BY is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByEqualTo(String value) {
            addCriterion("UPDATE_BY =", value, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByNotEqualTo(String value) {
            addCriterion("UPDATE_BY <>", value, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByGreaterThan(String value) {
            addCriterion("UPDATE_BY >", value, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY >=", value, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByLessThan(String value) {
            addCriterion("UPDATE_BY <", value, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY <=", value, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByLike(String value) {
            addCriterion("UPDATE_BY like ", value, "UPDATE_BY", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByNotLike(String value) {
            addCriterion("UPDATE_BY  not like ", value, "UPDATE_BY", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByLeftLike(String value) {
            addCriterion("UPDATE_BY like ", value, "UPDATE_BY", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByNotLeftLike(String value) {
            addCriterion("UPDATE_BY  not like ", value, "UPDATE_BY", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByRightLike(String value) {
            addCriterion("UPDATE_BY like ", value, "UPDATE_BY", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByNotRightLike(String value) {
            addCriterion("UPDATE_BY  not like ", value, "UPDATE_BY", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByIn(List<String> values) {
            addCriterion("UPDATE_BY  in ", values, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByNotIn(List<String> values) {
            addCriterion("UPDATE_BY not in ", values, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByBetween(String value1, String value2) {
            addCriterion("UPDATE_BY between ", value1, value2, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY not between ", value1, value2, "UPDATE_BY");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkLike(String value) {
            addCriterion("REMARK like ", value, "REMARK", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkNotLike(String value) {
            addCriterion("REMARK  not like ", value, "REMARK", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkLeftLike(String value) {
            addCriterion("REMARK like ", value, "REMARK", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkNotLeftLike(String value) {
            addCriterion("REMARK  not like ", value, "REMARK", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkRightLike(String value) {
            addCriterion("REMARK like ", value, "REMARK", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkNotRightLike(String value) {
            addCriterion("REMARK  not like ", value, "REMARK", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkIn(List<String> values) {
            addCriterion("REMARK  in ", values, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in ", values, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between ", value1, value2, "REMARK");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between ", value1, value2, "REMARK");
            return (TsSyUserCriteria) this;
        }
        public TsSyUserCriteria andIsEnableIsNull() {
            addCriterion("IS_ENABLE is null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableIsNotNull() {
            addCriterion("IS_ENABLE is not null");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableEqualTo(String value) {
            addCriterion("IS_ENABLE =", value, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableNotEqualTo(String value) {
            addCriterion("IS_ENABLE <>", value, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableGreaterThan(String value) {
            addCriterion("IS_ENABLE >", value, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableGreaterThanOrEqualTo(String value) {
            addCriterion("IS_ENABLE >=", value, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableLessThan(String value) {
            addCriterion("IS_ENABLE <", value, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableLessThanOrEqualTo(String value) {
            addCriterion("IS_ENABLE <=", value, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableLike(String value) {
            addCriterion("IS_ENABLE like ", value, "IS_ENABLE", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableNotLike(String value) {
            addCriterion("IS_ENABLE  not like ", value, "IS_ENABLE", 1);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableLeftLike(String value) {
            addCriterion("IS_ENABLE like ", value, "IS_ENABLE", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableNotLeftLike(String value) {
            addCriterion("IS_ENABLE  not like ", value, "IS_ENABLE", 0);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableRightLike(String value) {
            addCriterion("IS_ENABLE like ", value, "IS_ENABLE", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableNotRightLike(String value) {
            addCriterion("IS_ENABLE  not like ", value, "IS_ENABLE", 2);
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableIn(List<String> values) {
            addCriterion("IS_ENABLE  in ", values, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableNotIn(List<String> values) {
            addCriterion("IS_ENABLE not in ", values, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableBetween(String value1, String value2) {
            addCriterion("IS_ENABLE between ", value1, value2, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

        public TsSyUserCriteria andIsEnableNotBetween(String value1, String value2) {
            addCriterion("IS_ENABLE not between ", value1, value2, "IS_ENABLE");
            return (TsSyUserCriteria) this;
        }

    }

    public static class TsSyUserCriteria extends GeneratedCriteria {

        protected TsSyUserCriteria() {
            super();
        }
    }

    public static class TsSyUserCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected TsSyUserCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected TsSyUserCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected TsSyUserCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected TsSyUserCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected TsSyUserCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected TsSyUserCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}